//模型创建 https://www.sequelize.com.cn/core-concepts/model-basics#%E5%AD%97%E7%AC%A6%E4%B8%B2

//分类
module.exports = ( sequelize, Sequelize ) => {
    return sequelize.define( "project", {
        id: {
            type: Sequelize.UUID,
            notNull: true,
            primaryKey: true,
            defaultValue: Sequelize.UUIDV4 // 或 DataTypes.UUIDV1
        },
        name: {
            type: Sequelize.STRING,
            comment: '项目名称',
             
        },
        startTime: {
            type: Sequelize.STRING,
            comment: '开始时间',
        },
        endTime: {
            type: Sequelize.STRING,
            comment: '结束时间',
        },
        cycle: {
            type: Sequelize.STRING,
            comment: '项目周期',
        },
        description: {
            type: Sequelize.STRING,
            comment: '项目描述',
        },
        duty: {
            type: Sequelize.STRING, 
            comment: '项目职责',
        },
         link: {
             type: Sequelize.STRING,
             comment: '链接',
        },
          achieve: {
              type: Sequelize.STRING,
              comment: '实现业绩',
        },
          show: {
              type: Sequelize.STRING,
              comment: '是否显示',
              defaultValue: 1
          },
           art: {
               type: Sequelize.STRING,
               comment: '所使用技术',
           },
    }, {
        tableName: 'project'
    } );
};
